============================================================================

        IBM i Access Client Solutions - Windows Application Package

                         5733-XJ1 Version: 1.1.0.27 (This is an updated version previously shipped)
                         ESS ID: LCD8-2011-17       (This is an updated version previously shipped)


(c) Copyright IBM Corporation 2022.  All rights reserved.

=============================================================================



NOTICE:

-------

   Application of this Service Pack may disable or render ineffective programs

   that use system memory addresses not generated by the IBM translator,

   including programs that circumvent control technology designed to limit

   interactive capacity to purchased levels. This Service Pack may be a

   prerequisite for future Service Packs. By applying this Service Pack you

   authorize and agree to the foregoing.



   This Service Pack is subject to the terms of the license agreement which

   accompanied, or was contained in, the Program for which you are obtaining

   the Service Pack.  You are not authorized to install or use the Service Pack

  except as part of a Program for which you have a valid Proof of Entitlement.



   SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY

   AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT

   AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED,

   INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF

  MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT,

   REGARDING THE SERVICE PACK.



   The applicable license agreement may have been provided to you in printed

   form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR)

   CL command.

---------------------------------
Version: 1.1.0.27 (This is an updated version previously shipped)
Build Date = June 2023
The installed files will be in:
    C:\Program Files (x86)\IBM\Client Access  (OR)
    C:\Program Files\IBM\Client Access
    Build date: 6/27/2023
---------------------------------

This update includes:
IBM GSKit version 8.0.55.31 with the latest security updates.

After installing this update, to verify IBM GSKIT has been updated:
1. Open the "IBM i Access Client Solutions" folder on the Desktop 
2. Double click Properties.  Answer yes to the prompt.
3. Select the "Secure Sockets" tab
4. Verify the "IBM i Access client encryption" is 8.0.55.31


---------------------------------
Version: 1.1.0.27
Build Date = November 2022
---------------------------------
When using TLS (SSL), SSLv3, TLS 1.0, and TLS 1.1 are now disabled. TLS 1.3 is
also now enabled, but only when FIPS mode is disabled since the current GSKit
FIPS module does not yet support TLS 1.3.

APAR SE78010 OSP-INCORROUT ODBC CONFIGURATION WINDOW DOES NOT OPEN
APAR SE78013 OSP ACS WINAP OLEDB OLDER EXCEL MIGHT CRASH
APAR SE78044 OSP-INCORROUT ODBC INCORRECT COLUMN LABEL INFORMATION
APAR SE78102 OSP-UNPRED WINAP 1.1.0.26 - MICROSOFT CURSOR ENGINE: DATA
             PROVIDER OR OTHER SERVICE RETURNED AN E_FAIL STATUS
APAR SE78694 OSP-UNPRED PASE - ODBC - DBCS - SQL0104 FOR SELECT SQL STATEMENT


---------------------------------
Version: 1.1.0.26
Build date = May 2022
---------------------------------
APAR SE75789 OSP .NET DRIVER WILL NOT ALWAYS CATCH THEN EXCEPTION IN A TRY CATCH CLAUSE
APAR SE75879 OSP-INCORROUT SYSTEM KEYWORD NOT RECOGNIZED IN DSN-LESS ODBC CONNECTION
APAR SE76176 OSP-INCORROUT ODBC - CWBNL0107 FOR SPECIFIC CHARACTERS WITH TARGET CODE PAGE 1202
APAR SE76907 OSP-INCORROUT ACTIVEX DATA QUEUE TEXT BOX CONTROL CHARACTER CONVERSION INCORRECT.
APAR SE77094 OSP-THREADS-WAIT PASE ODBC DRIVER DELAY SQLGETINFO
APAR SE75812 OSP-UNPRED MEMORY LEAK IN ODBC DRIVER


---------------------------------
Version: 1.1.0.25
Build date = May 2021
---------------------------------
APAR SE75377 OSP-INCORROUT CWBOBJ_OPENLIST API GENERATES AN EXCEPTION
APAR SE75463 OSP ACS WINDOWS AP ODBC {FN CURRENT_DATE()} MIGHT CRASH WITH WHERE CLAUSE
APAR SE75755 OSP-UNPRED CUSTOMER'S APPLICATION HANGS WHEN USER PROFILE PASSWORD EXPIRATION INTERVAL IS MET


---------------------------------
Version: 1.1.0.24
Build date = August 2020
---------------------------------
APAR SE73817 OSP-INCORROUT ONLY 200 ROWS OF DATA ARE FETCHED BY ODBC DRIVER


---------------------------------
Version: 1.1.0.23
Build date = February 2020
---------------------------------
IBM Key Management has been removed from this update as it was part of the IBM JRE 1.6 which has been removed. A replacement will not be provided. For importing certificates to Windows, IBM i Access Client Solutions (ACS) provides two options:
1. The cwbcossl command is still available as part of the Windows Application Package.
2. In the ACS base package, from the main GUI, select Tools->Key Management. From there you can select a certificate and the option to Push to Windows...
Installed versions of Java provide a command line tool (keytool) for other certificate management functions.

APAR SE72583: CA400EXP-OLEDB-INCORROUT BLOCK SIZE PROPERTY IGNORED
APAR SE72916: OSP INSTALLING ACS WINDOWS APPLICATION PACKAGE WITH LANGUAGE BRAZILAN PORTUGESE MIGHT FAIL
RFE   137587: Remove JRE 1.6

---------------------------------
Version: 1.1.0.22
Build date = May 2019
---------------------------------
APAR SE70688: CA400EXP-SERVICE-INCORROUT CWBSVGET LOG MISSING REGISTRY DATA
APAR SE71039: CA400EXP-APIS-NLS-INCORROUT CCSID 937 USING 28709 FOR SBCS RATHER THAN 37
APAR SE71097: CA400EXP-ODBC-MSGSQL0181 LINUX ODBC DRIVER CONVERTING STRING TO TIME INCORRECTLY
APAR SE71133: CA400EXP-ODBC-THREADS-PERFM IBM I ACCESS CLIENT SOLUTIONS LINUX ODBC DRIVER MEMORY USAGE GROWTH


---------------------------------
Version: 1.1.0.21
Build date = November 2018
---------------------------------
APAR SE69991: CA400EXP-ODBC-MSGSQL0904 RESOURCE LIMIT TYPE 7 EXCEEDED WITH REASON CODE 168


---------------------------------
Version: 1.1.0.20
Build date = May 2018
---------------------------------
APAR SE68537: CA400EXP-OLEDB-F/QSQCLNUP-T/QSQCLNUP-RC13-MSGSQL0904
              BLOCK SIZE TOO SMALL
APAR SE68605: CA400EXP-IDB2DATA-THREADS-PERFM SLOW THREADS LOOKING
              FOR OPEN CONNECTIONS WHEN A CONNECTION IS BEING VERIFIED OR CLOSED
APAR SE68390: CA400EXP-COMM-INCORROUT MISSING HELP TEXT
APAR SE68793: OSP-UNPRED ACS WINDOWS ODBC DRIVER WILL FAIL WITH ACCESS VIOLATION
              WHEN USING *USRLIBL AT 64 BIT DATA SOURCE
APAR SE68610: CA400EXP-ODBC-INCORROUT TIMESTAMP PRECISION
APAR SE68844: OSP-INCORROUT ODBC HEAP ADDRESS ERRORS OR DELPHI DEBUGGER STOPS AT
              A "NON-USER BREAKPOINT"
APAR SE68848: OSP-INCORROUT ODBC EXCEL MSQUERY DOES NOT WORK TO CHANGE THE QUERY


---------------------------------
Version: 1.1.0.18
Build date = October 2017
---------------------------------
APAR SE68044: CA400EXP-SSL-INCORROUT CWBCOSSL FAILS TO IMPORT JAVA CA
APAR SE67343: CA400EXP-IDB2DATA-INCORROUT .NET MANAGED PROVIDER MISSING
              PARAMETER EXCEPTION FOR QUESTION MARK IN AN SQL COMMENT
APAR SE67749: CA400EXP-IDB2DATA-INCORROUT IDB2DATAADAPTER INCORRECT
              WIDTH FOR GRAPHIC, VARGRAPHIC AND DBCLOB FIELDS

---------------------------------
Version: 1.1.0.16
Build date = May 2017
---------------------------------
APAR SE66926: CA400EXP-IKEYMAN DOES NOT HONOR THE PROPERTIES LANGUAGE
              TAB SETTING
APAR SE66636: CA400ECP-ODBC-INCORROUT SQL_NO_TOTAL PROBLEM WITH ODBC
APAR SE66663: CA400EXP-ODBC-INCORROUT ALL COLUMN VALUES BOUND AS NULL
              WHEN USING BLOCK INSERT
APAR SE66664: CA400EXP-IDB2DATA-MSGSQL0666 .NET MANAGED PROVIDER
              COMMANDTIMEOUT NOT CHANGED
APAR SE64933: CA400EXP-OLEDB-MSGSQL0104 LINKED SERVER OPENQUERY
              INSERT FAILING WHEN USING SYSTEM NAMING CONVENTION
              AND NO LIBRARY NAME
APAR SE67000: CA400EXP AFP VIEWER WILL RECEIVE A 1393: MESSAGE WHEN
              LOOKING AT SPOOLFILE WITH BARCODE

---------------------------------
Version: 1.1.0.15
Build date = October 2016
---------------------------------
APAR SE65806: CA400EXP-INCORROUT CONVERSION TABLE DOWNLOAD SYSTEM
               VARIES
APAR SE65922: CA400EXP-ODBC-UNPRED Data is messed up if no shift-in
APAR SE65773: OSP SQLDRIVERCONNECT NOT REPORTING ERRORS CORRECTLY IN
              LAST TWO SERVICE PACKS

---------------------------------
Version: 1.1.0.14
Build date = May 2016
---------------------------------
APAR SE64636: CA400EXP-INSTALL-UNPRED MISSING MFCLOC MODULES
APAR SE63488: CA400EXP-DTRANSFER-INCORROUT CWBTF0005 FOR THE COLUMN
              HEADING
APAR SE64833: CA400EXP-DTRANSFER-INCORROUT DT FAILURES NOT REPORTED
APAR SE63287: CA400EXP-ODBC-INCORROUT CWB0111 UTF-8 PARAMETER DATA
APAR SE63307: CA400EXP-ODBC-INCORROUT FILE DSN SIGNON TYPE
APAR SE63628: CA400EXP-ODBC-UNPRED FIELD DATA IS TRUNCATED
APAR SE63700: CA400EXP-ODBC-INCORROUT LINUX ODBC NOT RETURNING COLUMN
              NAMES CORRECTLY TO CALLER
APAR SE63801: CA400EXP-ODBC-INCORROUT ERROR INVALID PARAMETER NUMBER
              RETURNED AFTER CALLING SQLFREESTMT(SQL_RESET_PARAMS)
APAR SE64596: CA400EXP-ODBC-UNPRED UNEXPECTED 0F0E INSERTED BETWEEN
              KANJI AND DBCS BLANKS
APAR SE64600: CA400EXP-ODBC-INCORROUT DATES AND TIMES NOT CONVERTED
              TO WIDE CHARACTERS
APAR SE64252: CA400EXP-IDB2DATA-INCORROUT .NET CONNECTION CLOSED BY
              GARBAGE COLLECTOR IS CAUSING EXCEPTION
APAR SE63893: CA400EXP-AFPVIEWER-INCORROUT DEFAULT BARCODE HEIGHT WAS
              GETTING CHANGED BETWEEN EACH BARCODE
APAR SE64884: CA400EXP-DTRANSFER-INCORROUT RTOPCB BIFF8 LOST DECIMALS

---------------------------------
Version: 1.1.0.13
Build date = October 2015
---------------------------------
APAR SE62758: CA400EXP-ODBC-UNPRED EVENT-ID 1000 LOGGED IN WINDOWS EVENT LOG
              FOR CWBODBC.DLL WHEN AN APPLICATION CONNECTS TO IBM I 7.2 SYSTEM
APAR SE62994: CA400EXP-ODBC-UNPRED ACS APPLICATION PACKAGE FOR LINUX ODBC
              DRIVER "CCSID" CONNECTION STRING KEYWORD NOT WORKING AS DESIGNED


---------------------------------
Version: 1.1.0.12
Build date = May 2015
---------------------------------

APAR SE61342: CA400EXP-ODBC-F/QSQRUN2-T/QSQRUN2-RC501-MSGMSGSQL0501
              INSTALLATION OF SI53809 CAUSES SQL0501 IN ODBC APPLICATION
APAR SE61465: CA400EXP-ODBC-INCORROUT ODBC FAILING IN FOXPRO
APAR SE61519: CA400EXP-IDB2DATA-THREADS-INCORROUT IMPROVE ERROR FOR
              CONVERSION FAILURES

---------------------------------
Version: 1.1.0.11
Build date = February 2015
---------------------------------

APAR SE61082: CA400EXP-INCORROUT YEN SYMBOL CONVERSION ERROR WITH SI53809
APAR SE60616: CA400EXP-ODBC-INCORROUT ODBC CONNECTION FAILS WITH NO PRIMARY KEYS
APAR SE61173: CA400EXP-ODBC-INCORROUT RESTRICTED DATA TYPE ATTRIBUTE VIOLATION
              CALLING SQLGETDATA WITH 0 BYTE BUFFER
APAR SE61221: CA400EXP-ODBC-INCORROUT ODBC INSERT DATA CORRUPTED WITH SERVICE
              PACK SI53809

---------------------------------
Version: 1.1.0.11
Build date = October 2014
---------------------------------

APAR SE59290: CA400EXP-ODBC-MSGSQL0952 PROGRAM CALL INTERMITENT TIMEOUT
APAR SE59344: CA400EXP-ODBC-UNPRED APPLICATION FAULTS AND CLOSES ON A QUERY
              THAT DOES A CALCULATION
APAR SE59386: CA400EXP-ODBC-INCORROUT UNEXPECTED CHARACTERS IN OUTPUT DOING A
              SIMPLE SELECT STATEMENT
APAR SE59960: CA400EXP-ODBC-UNPRED CWBODBCREG LIMITATIONS
APAR SE60184: CA400EXP-ODBC-MSGSQL0180 ODBC SELECT & INSERT STATEMENTS FAIL
              WITH MSGSQL0180 IN IBM I ACCESS FOR WINDOWS SERVICE PACK SI53584
APAR SE60361: CA400EXP-ODBC-PERFM BLOCKING WITH LOB LOCATORS
APAR SE59245: CA400EXP-OLEDB-INCORROUT DATA TRUNCATED ON INSERT
APAR SE59367: CA400EXP-OLEDB-INCORROUT STATEMENT NOT FOUND
APAR SE60314: CA400EXP-IDB2DATA-INCORROUT .NET PROVIDER TIMESTAMP PROBLEMS

---------------------------------
Version: 1.1.0.10
Build date = May 2014
---------------------------------

APAR SE57158: CA400EXP-CONNECTIONS-INCORROUT CWBSY0002 ON WINDOWS 8.1
APAR SE57535: CA400EXP-SECURITY-UNPRED NO PASSWORD CHANGE FAILURE DETAIL
APAR SE56950: CA400EXP-DTRANSFER-UNPRED CWBTF0105 ON XLS UPLOAD TO IBM I
APAR SE57759: CA400EXP-ODBC-INCORROUT INCORRECT HANDLING OF ROW-WISE PARAMETER
              BINDING
APAR SE57797: CA400EXP-ODBC-INCORROUT SQLGETTYPEINFO (ALL DATATYPES) THROWS
              INCORRECT OUTPUT FOR CREATE_PARAMS
APAR SE57867: CA400EXP-ODBC-INCORROUT SQLCOLUMNS() REPORTS DATA_TYPE &
              SQL_DATA_TYPE AS -1 (LONGVARCHAR), NOT -370 (XML)
APAR SE58113: CA400EXP-ODBC-UNPRED MSGCWBNL0107 WHEN RECORD DOES HAVE X'E0'
              (SHIFT OUT) BUT NO X'0F' (SHIFT IN)
APAR SE57049: CA400EXP-IDB2DATA-MSGSQL0519 CONNECTION WITH IBM I ACCESS FOR
              WINDOWS .NET DRIVER RESULTS IN SQL0519 WHEN SQL COMMENTS ADDED
APAR SE57162: CA400EXP-IDB2DATA-INCORROUT FORMAT EXCEPTION DURING CONNECTION
APAR SE57569: CA400EXP-AFPVIEWER-UNPRED AFP WORKBENCH VIEWER (FTDWINVW.EXE)
              CANNOT START BECAUSE ICUUC44.DLL MISSING

---------------------------------
Version: 1.1.0.9
Build date = October 2013
---------------------------------

APAR SE56004: CA400EXP-DTRANSFER-UNPRED MSGCWBTF0005 WITH YEN SIGN IN FIELD
              NAME DURING UPLOAD TO IBM I
APAR SE56678: CA400EXP-UNPRED HEAP FREELIST CORRUPTION BY CWBCORE.DLL
APAR SE56576: CA400EXP-IDB2DATA-INCORROUT CANCEL FUNCTION WITH .NET PROVIDER
              SENDS INVALID PASSWORD
APAR SE56657: CA400EXP-DTRANSFER-INCORROUT CWBDB0014 - INTERNAL SOFTWARE ERROR
              (SYSTEM %1)
APAR SE54136: CA400EXP-AFPVIEWER-INCORROUT QUALITY OF THE VIEWED PAGE IS NOT
              AS GOOD AS BEFORE
APAR SE54364: CA400EXP-AFPVIEWER PRINT ALL PAGES WITH AFP WORKBENCH VIEWER
              GENERATES BLANK OUTPUT
APAR SE54590: CA400EXP-AFPVIEWER AFP VIEWER DOES NOT VIEW TWO OVERLAYS FROM
              DIFFERENT LIBRARIES

-------------------------------------------------------------------
[END OF DOCUMENT]
